IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'spCategories_Update')
	BEGIN
		PRINT 'Dropping Procedure spCategories_Update'
		DROP  Procedure  spCategories_Update
	END

GO

PRINT 'Creating Procedure spCategories_Update'
GO
Create Procedure dbo.spCategories_Update
	( 	  
		@CategoryName varchar(50), 
		@DivisionName varchar(50), 
		@DepartmentName varchar(50)
	)
AS
  /* 
    ------------------------------------------------------------------------------
    - Change History
    - --------------
    - Date          Description
    ------------------------------------------------------------------------------
    - 2007/11/02    Initial version Updated
    ------------------------------------------------------------------------------
  */

	-- Declare the required variables

	-- Update the required new record
	UPDATE Categories
	SET
		CategoryName = @CategoryName, 
		DivisionName = @DivisionName		
	WHERE DepartmentName = @DepartmentName

	-- Return to calling method
	RETURN
	
GO
